Excel 2016 Formulas (Mr. Spreadsheet's Bookshelf) by Michael Alexander & Richard Kusleika

Author:Michael Alexander & Richard Kusleika [Alexander, Michael]
Language: eng
Format: azw3, epub
ISBN: 9781119067986
Publisher: Wiley
Published: 2016-01-21T05:00:00+00:00

Note

Other language versions of Excel may use characters other than commas and semicolons.

The following example shows a 3 × 4 array constant:

{1,2,3,4;5,6,7,8;9,10,11,12}

Displaying this array in a range requires 12 cells. To enter this array into a range, select a range of cells that consists of three rows and four columns. Then type the following formula and press Ctrl+Shift+Enter:

={1,2,3,4;5,6,7,8;9,10,11,12}

Figure 14.3 shows how this array appears when entered into a range (in this case, B3:E5).

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.